package ai.llz.ai_pro;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface TableMapper {
    @Select("select * from `table`\n" +
            "where `name` like concat('%',#{name},'%')\n" +
            "and `key` like concat('%',#{key},'%')")
    List<Entity> getValue(@Param("name") String  name, @Param("key") String key);

    @Select("select * from `table`\n" +
            "where `name` = #{name}\n" +
            "and `key` like concat('%',#{key},'%')")
    List<Entity> getValueEle(@Param("name") String  name, @Param("key") String key);

}
